package com.quan.mall.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.github.pagehelper.Page;
import com.quan.common.base.bean.PageBean;
import com.quan.common.core.BaseMapper;
import com.quan.mall.entity.MallGoodsSpecAttr;

/**
 * <p>
 * 电商-商品规格属性表 Mapper 接口
 * </p>
 *
 * @author 杨浩泉
 * @since 2018-10-25
 */
public interface MallGoodsSpecAttrMapper extends BaseMapper<MallGoodsSpecAttr> {
	
	public List<MallGoodsSpecAttr> selectSpecAttrAndValueByCategoryId(@Param("categoryId") Long categoryId) ;
	
	public List<MallGoodsSpecAttr> selectSpecAttrAndValueByBrandId(@Param("brandId") Long brandId) ;
	
	public List<MallGoodsSpecAttr> selectSpecAttrAndValueByTypeId(@Param("typeId") Long typeId) ;
	
	public Page<MallGoodsSpecAttr> selectPageAssociationCategoryAndBrandAndType(@Param("entity") MallGoodsSpecAttr entity, @Param("pageBean") PageBean pageBean) ;
	
}
